
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spSuppliersGetListByConPoint]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [spSuppliersGetListByConPoint]
GO

	
CREATE PROCEDURE spSuppliersGetListByConPoint
	@ConPointID int
AS

SELECT
	[SupplierCode],
	[SupplierName],
	[ConPointID],
	[IsArchived]
FROM
	 [Suppliers]
WHERE ConpointID = @ConPointID
GO

	
